BI-Uday-Naveen-Dhananjay - 2017-04-12 - 23620 - Enhancement - Build datasource and connections(Filip Szabluk by 2017-04-29) #wipdoc
Specification
23620 - Build datasource and connection
Purpose
Need to extract condition level item data in to BW
Admin Info
Purpose
|
Need to extract condition level item data in to BW & Fix all issues related to Purchase Infocube
|
Requested By
|
Filip Szabluk
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
2017-04-12
|
Spec QA by
|
Uday Kumar
|
Objects
|
ZPO_O01, ZAFMM_C03
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
50
|
2
|
Documentation
|
20
|
3
|
Development/ Config
|
150
|
4
|
Unit test in DEV
|
60
|
5
|
Unit test in QUA
|
60
|
6
|
Other activity
|
20
|
|
TOTAL
|
360
|
References
Prior Tickets
35681 - Currency inquiry in Explorer and add Plant_ID in Universe
38001 - Updating new changes to Explorer Spaces, and Universe
35421 - Season Consolidated data is blank
Documents
Design Document_V001.docx
Spec Changes
S.No
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Calculate exchange rate for Received value based on posting date
|
Jennifer Lawrence
|
04/28/2017
|
|
2
|
Add Delivery Date & Shipping instructions from PO Function module
|
Jennifer Lawrence
|
05/20/2017
|
|
3
|
Need to update season & collection to PO infocube
|
Jennifer Lawrence
|
06/01/2017
|
|
Functional Requirement
Purpose/WHY:
User would like to see the ACTUALs as currently they do not have visibility of BY Materials, Landed Cost, Cost paid to the vendors, Duty, Freight, and the overall cost to bring the product in, neither they can see what is the INVOICE and if it is an INVOICE, how much quantity delivered.
The landed cost is the sum of amount paid to vendors, Duty, Freight, and Over Heads, where all these values currently coming from PO Cube which is at Schedule line level and are incorrect. The new PO design would help users get correct and detailed information to make better decisions.
In Scope:
Need to create new DSO & extract condition data from PO Function module
Out of Scope:
None
Solution Summary
1. Need to create function module to extract condition data based on purchasing document.
2. Need to create a new DSO, which stores data for Condition data.
3. Need to add “Your Reference” & “ Delivery Date” from Function module & updated the same to PO item Infocube.
4. Need to Add Shipping Instructions, PO issue Date(PO creation Date) & Your reference fields to BEx Queries related to Analysis & Explorer.
5. Need to Calculate Order Price & Received Price based on Qty*Netprice.
6. Need to Change the calculations in BEx Query for Received Value & Received price.
7. Need to Activate new text extractor to fetch text descriptions to Shipping instructions infoobjects.
8. Need to Automate the dataloads for Season collection & Purchasing data flow.
9. Need to create a new Crystal report to fetch Season, Collection & update to 0MAT_SALES infoobject
10. Need to validate the changes thoroughly in BPD & BPQ with all the possible scenarios
Test Plan
UAT Document_Results_Updated.xlsx
Solution Details
1. Need to create function module ZDS_PO_CONDITIONS to extract condition data based on purchasing document.
2. Need to create a new DSO ZPO_O01, which stores data for Condition data.
3. Need to create a new infocube ZAFMM_C03
4. Need to add “Your Reference” ZYOUREF & “ Delivery Date” from Function module & updated the same to PO item Infocube.
5. Need to Add Shipping Instructions, PO issue Date(PO creation Date) & Your reference fields to BEx Queries related to Analysis & Explorer.
6. Need to Calculate Order Price & Received Price based on Qty*Netprice.
7. Need to Change the calculations in BEx Query for Received Value & Received price.
8. Need to Activate new text extractor to fetch text descriptions to Shipping instructions infoobjects.
9. Need to Automate the dataloads for Season collection & Purchasing data flow.
10. Need to create a new Crystal report to fetch Season, Collection & update to 0MAT_SALES infoobject
11. Need to validate the changes thoroughly in BPD & BPQ with all the possible scenarios
12. Need to collect all the necessary changes into the transport request
Issues
None